#!/usr/bin/python2.7
#coding=utf8

import datetime
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Index, Sequence, BigInteger, Integer, DateTime, Numeric, String, Unicode, UnicodeText, Text

Base = declarative_base()

class T_MARKET(Base):
    __tablename__ = 'T_MARKET'
    jzrq = Column(String(8), primary_key=True)
    ha_stock = Column(Numeric(38))
    ha_found = Column(Numeric(38))
    sz_stock = Column(Numeric(38))
    sz_found = Column(Numeric(38))
    total_value = Column(Numeric(38))
    create_time = Column(DateTime, nullable=False, default=datetime.datetime.now())
    update_time = Column(DateTime, nullable=False, default=datetime.datetime.now())

